Grid Presentation Settings

When working with a crosstabulation, the Grid tab displayed above the Ribbon bar allows you to customize the appearance of the grid including the colors, grid lines and labels used, and also to resize grid columns.

You can add or modify a grid title by flipping the grid to display the layout configuration settings.

Customizing Colors

You can select the color of various areas of the grid by clicking the drop-down arrow next to area you want to customize and selecting the required color. The selected color is then applied to the grid.

Customizing Lines and Labels

You can select from any of the following options to customize the grid lines and labels:

• Horizontal Lines: click this button to display horizontal grid lines.
• Vertical Lines: click this button to display vertical grid lines.
• Show All Labels: click this button to display a label showing the details of each measure applied to the grid.

Resizing the Grid

You can resize any column in the grid by hovering the mouse over the column edge to display the resize icon

Then drag the column to the required position.

You can also manually configure the width and height of rows and columns using the grid layout configuration settings.

• Crosstab Grid
  • Defining a Crosstab Grid
  • Grid Presentation Settings
  • Saving a Grid as a Template
  • Template Toolbar
  • Creating an Excel Template
  • Exporting to Excel